HJB 12/4/2016 | |
Replace 44E5083 with \'44E5083\' |
W
|
wijninga author 12/4/2016 |
Replace 44E5083 with \'44E5083\'
|
HJB 12/4/2016 | |
Think, "custom field" with \' as prefix and \' as suffix should be a way out here, |
admin 12/4/2016 | |
You need to explain when exactly this error is happening. What "when I hit a page with that partnumber" means? |
kujox 12/4/2016 | |
is this happening when you're doing some kind of import or restore using the actual data rather than a variable? |
W
|
wijninga author 12/4/2016 |
You need to explain when exactly this error is happening. What "when I hit a page with that partnumber" means? PHPRunner builds SQL queries based on data types in the database. The format of data itself is irrelevant.
|
W
|
wijninga author 12/4/2016 |
is this happening when you're doing some kind of import or restore using the actual data rather than a variable?
|
W
|
wijninga author 12/4/2016 |
You need to explain when exactly this error is happening. What "when I hit a page with that partnumber" means? PHPRunner builds SQL queries based on data types in the database. The format of data itself is irrelevant.
|
kujox 12/4/2016 | |
This is the exact error message: php error happened Technical information Error type 256 Error description Illegal double '44E5083' value found during parsing URL 192.168.212.13/InventoryMutationsIncomingPO_list.php?pagesize=-1 Error file /var/www/html/connections/Connection.php Error line 642 SQL query SELECT Partnumbers .Part_ID , concat(Partnumber ,' - ',PartDescription ,' - ',Manufacturer .ManufacturerDescription ), Partnumbers .Partnumber , concat(CAST(Partnumber as CHAR(60)), ' - ', PartDescription , ' - ', Manufacturer .ManufacturerDescription ) FROM Partnumbers INNER JOIN Manufacturer ON Partnumbers .Manufacturer_ID = Manufacturer.Manufacturer_ID WHERE (Partnumbers .Active =1) and (Partnumbers.Part_ID = 44E5083)
|
W
|
wijninga author 12/4/2016 |
I can see the issue in the query, as it's a text field it should have '' around it, I'm sure PHPrunner should wrap them around the text automatically.
|
lefty 12/4/2016 | |
Thanks Kujox, exactly my point! But there is something really strange going on. Because the field Part_ID is a unique int. The 44E5083 is in the Partnumber field.... So why is PHPRunner creating this strange and wrong query when accessing the list page...
|
W
|
wijninga author 12/4/2016 |
Have you tried without joining tables and just see if the partnumber throws error on your list page . I would start there . Which version of PHP do you use? Is it older than 5.5? on your server? Also is that query in your mysql or is it exactly like that in your phprunner query ? If it is in your mysql table / sync in php and look at query. Anything different and do results work? what are the partnumbers in all tables set as , I assume varchar in all tables?
|
lefty 12/4/2016 | |
Thanks Kujox, exactly my point! But there is something really strange going on. Because the field Part_ID is a unique int. The 44E5083 is in the Partnumber field.... So why is PHPRunner creating this strange and wrong query when accessing the list page...
|
admin 12/5/2016 | |
Lots of confusions here. |
jadachDevClub member 12/5/2016 | |
You might want to check the view as config and make sure the validation isn't numeric. |